WMI Filters¶
Client Operating Systems¶
1 | select * from Win32_OperatingSystem WHERE ProductType="1" |
Domain Controllers¶
1 | select * from Win32_OperatingSystem WHERE ProductType="2" |
Member Servers¶
1 | select * from Win32_OperatingSystem WHERE ProductType="3" |
Any Windows Desktop OS – 32-bit¶
1 | select * from Win32_OperatingSystem WHERE ProductType = "1" AND NOT OSArchitecture = "64-bit" |
Any Windows Desktop OS – 64-bit¶
1 | select * from Win32_OperatingSystem WHERE ProductType = "1" AND OSArchitecture = "64-bit" |
DESKTOPS¶
Any Windows Desktop OS¶
1 | select * from Win32_OperatingSystem WHERE ProductType = "1" |
Windows XP¶
1 | select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" |
Windows XP – 32-bit¶
1 | select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" AND NOT OSArchitecture = "64-bit" |
Windows XP – 64-bit¶
1 | select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" AND OSArchitecture = "64-bit" |
Windows Vista¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" |
Windows Vista – 32-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" |
Windows Vista – 64-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" AND OSArchitecture = "64-bit" |
Windows 7¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" |
Windows 7 – 32-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" |
Windows 7 – 64-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND OSArchitecture = "64-bit" |
Windows 8¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" |
Windows 8 – 32-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" |
Windows 8 – 64-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND OSArchitecture = "64-bit" |
Windows 8.1¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" |
Windows 8.1 – 32-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" |
Windows 8.1 – 64-bit¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND OSArchitecture = "64-bit" |
SERVERS¶
Any Windows Server OS¶
1 | select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") |
Any Windows Server OS – 32-bit¶
1 | select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") AND NOT OSArchitecture = "64-bit" |
Any Windows Server OS – 64-bit¶
1 | select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") AND OSArchitecture = "64-bit" |
Any Windows Server – Domain Controller¶
1 | select * from Win32_OperatingSystem where (ProductType = "2") |
Any Windows Server – Domain Controller – 32-bit¶
1 | select * from Win32_OperatingSystem where (ProductType = "2") AND NOT OSArchitecture = "64-bit" |
Any Windows Server – Domain Controller – 64-bit¶
1 | select * from Win32_OperatingSystem where (ProductType = "2") AND OSArchitecture = "64-bit" |
Any Windows Server – Non-Domain Controller¶
1 | select * from Win32_OperatingSystem where (ProductType = "3") |
Any Windows Server – Non- Domain Controller – 32-bit¶
1 | select * from Win32_OperatingSystem where (ProductType = "3") AND NOT OSArchitecture = "64-bit" |
Any Windows Server – Non-Domain Controller – 64-bit¶
1 | select * from Win32_OperatingSystem where (ProductType = "3") AND OSArchitecture = "64-bit" |
Windows Server 2003¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" |
Windows Server 2003 – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" |
Windows Server 2003 – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" |
Windows Server 2003 – 32-bit – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" AND NOT OSArchitecture = "64-bit" |
Windows Server 2003 – 32-bit – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" AND NOT OSArchitecture = "64-bit" |
Windows Server 2003 – 64-bit – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" AND OSArchitecture = "64-bit" |
Windows Server 2003 – 64-bit – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" AND OSArchitecture = "64-bit" |
Windows Server 2003 R2¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" |
Windows Server 2003 R2 – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" |
Windows Server 2003 R2 – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" |
Windows Server 2003 R2 – 32-bit – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" AND NOT OSArchitecture = "64-bit" |
Windows Server 2003 R2 – 32-bit – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" AND NOT OSArchitecture = "64-bit" |
Windows Server 2003 R2 – 64-bit – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" AND OSArchitecture = "64-bit" |
Windows Server 2003 R2 – 64-bit – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" AND OSArchitecture = "64-bit" |
Windows Server 2008¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" |
Windows Server 2008 – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" |
Windows Server 2008 – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" |
Windows Server 2008 – 32-bit – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND NOT OSArchitecture = "64-bit" |
Windows Server 2008 – 32-bit – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND NOT OSArchitecture = "64-bit" |
Windows Server 2008 – 64-bit – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND OSArchitecture = "64-bit" |
Windows Server 2008 – 64-bit – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND OSArchitecture = "64-bit" |
WINDOWS SERVER 2008 R2¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.1%" |
Windows Server 2008 R2 – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="2" |
Windows Server 2008 R2 – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="3" |
WINDOWS SERVER 2012¶
Windows Server 2012 – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="2" |
Windows Server 2012 – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="3" |
WINDOWS SERVER 2012 R2¶
Windows Server 2012 R2¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.3%" |
Windows Server 2012 R2 – DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="2" |
Windows Server 2012 R2 – non-DC¶
1 | select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="3" |